﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'P_ListBasicReferenceTypes')
BEGIN
	DROP  Procedure  [esf_sso].[P_ListBasicReferenceTypes]
END
GO

CREATE Procedure [esf_sso].[P_ListBasicReferenceTypes]
AS
BEGIN
	SELECT * FROM BasicReferenceType ORDER BY Name
END
GO